Entering date in cell need to show bi-weekly paydate in another

R

Rebecca

Excel - I am creating an HR form for wage adjustments. I need to enter a date
in one cell and have the associated bi-weekly paydate show in another cell on
the form.
 
P

protonLeah

Assuming paydys are around the 1st and 15th, something like:
=IF(DAY(A1)>15,A1+30-DAY(A1)+1,A1+15-DAY(A1))
should get you in the right direction...
 
D

daddylonglegs

Hi Rebecca, you haven't given much away.

If you always want to find the NEXT payday, after a date in A1,
assuming paydays are every 14 days, try this.

In B1 put any past paydate

in C1 use this formula

=CEILING(A1-B1,14)+B1
 
S

Sandy Mann

Rebecca/Victoria?

If you want to find the date with only one reference cell then try:

=CEILING(A1+0,14)-0

Which returns a Saturday date. To return the previous Thursday change the
+0 and -0 to 2's:

=CEILING(A1+2,14)-2

To return the "other" Thursday (ie the intervening Thursday) use:

=CEILING(A1+9,14)-9

Similarly +3 and -3 ( or +10 and -10) will return Wednesday etc

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk
 
Top