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

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

[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

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


"Rebecca" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Sandy Mann]

"Sandy Mann" <[email protected]> wrote in message
news:%23TY%[email protected]...
> Rebecca/Victoria?

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

--

Sandy
In Perth, the ancient capital of Scotland