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

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.

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

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


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=543978

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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=543978

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

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


with @tiscali.co.uk


"Rebecca" wrote in message
...
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.

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

"Sandy Mann" wrote in message
...
Rebecca/Victoria?

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

--

Sandy
In Perth, the ancient capital of Scotland