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

[Guest]

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.

 

[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...

 

[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

 

[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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

Rebecca/Victoria?

My Apologies for calling you Victoria - I don't know where that came from.