excel - Payweek calculation ending each Sunday -
i using next formula find week ends of sunday.
=ceiling.math(a5,7)+1 i had add together "+1" because getting saturday. problem happens on final sunday should have same pay week instead iterates next sunday.
12 oct resulting in 19 oct payweek. should end payweek.
formula:
=a5+(7-weekday(a5,2))
this formula convert date date of next sunday sunday returning spanning years , months.
excel
No comments:
Post a Comment